2016-02-23 - 25202 - Service Request - 2016 - BI Production Reports Fix #PendingDocReview

25202 - 2016 BI Production reports Fix

Problem Summary

Need to investigate & rescheduling the failed BI reports for all regions.

Admin Info

Purpose
 Need to investigate & rescheduling the failed BI reports for all regions.
Requested by
 Saravanan Lakshmanan
Issue Date
 02-23-2016
Resolved by
 Dhananjay
Resolved Date
 12/31/2016
Document Status
 WIP

Detailed Problem Description

BI reports are getting failed for all regions due to various reasons. This ticket shall be used to report the time invested on:
1. Rescheduling the failed reports.
2. Investigating the reason for report failure.
3. Communicating the issues with New Era team.
4. Identifying the root cause and working with New Era Team to fix it.
5. Analyzing the report failure pattern and communicating the trend.

Solution Analysis and Recommendations
SNo
 Week Ending
 No of Failed reports
 Comments
01
 08/01/2016
 14
 Refer attached spreadsheet.
02
 15/01/2016
 36
 Refer attached spreadsheet.
03
 22/01/2016
 24
 Refer attached spreadsheet.
04
 29/01/2016
 65
 Refer attached spreadsheet.
05
 05/02/2016
 128
 Refer attached spreadsheet.
06
 12/02/2016
 40
 Refer attached spreadsheet.
07
 19/02/2016
 29
 Refer attached spreadsheet.
08
 26/02/2016
 73
 Refer attached spreadsheet.
09
 04/03/2016
 68
 Refer attached spreadsheet.
10
 11/03/2016
 56
 Refer attached spreadsheet.
11
 18/03/2016
 80
 Refer attached spreadsheet
12
 25/03'2016
 30
 Refer attached spreadsheet
13
 01/04/2016
 51
 Refer attached spreadsheet
14
 07/04/2016
 26
 Refer attached spreadsheet
15
 15/04/2016
 35
 Refer attached spreadsheet
16
 22/04/2016
 67
 Refer attached spreadsheet
17
 29/04/2016
 163
 Refer attached spreadsheet
18
 06/05/2016
 64
 Refer attached spreadsheet
19
 13/05/2016
 18
 Refer attached spreadsheet
20
 20/05/2016
 27
 Refer attached spreadsheet
21
 27/05/2016
 49
 Refer attached spreadsheet
22
 03/06/2016
 19
 Refer attached spreadsheet
23
 10/06/2016
 09
 Refer attached spreadsheet
24
 17/06/2016
 28
 Refer attached spreadsheet
25
 24/06/2016
 48
 Refer attached spreadsheet
26
 01/07/2016
 11
 Refer attached spreadsheet
27
 07/08/2016
 11
 Refer attached spreadsheet
28
 07/15/2016
 16
 Refer attached spreadsheet
29
 07/22/2016
 22
 Refer attached spreadsheet
30
 07/29/2016
 06
 Refer attached spreadsheet
31
 05/08/2016
 07
 Refer attached spreadsheet
32
 12/08/2016
 09
 Refer attached spreadsheet
33
 19/08/2016
 16
 Refer attached spreadsheet
34
 26/08/2016
 36
 Refer attached spreadsheet
35
 02/09/2016
 21
 Refer attached spreadsheet
36
 09/09/2016
 06
 Refer attached spreadsheet
37
 16/09/2016
 16
 Refer attached spreadsheet
38
 23/09/2016
 12
 Refer attached spreadsheet
39
 30/09/2016
 12
 Refer attached spreadsheet
40
 07/10/2016
 19
 Refer attached spreadsheet
41
 14/10/2016
 09
 Refer attached spreadsheet
42
 21/10/2016
 46
 Refer attached spreadsheet
43
 28/10/2016
 20
 Refer attached spreadsheet
44
 04/11/2016
 27
 Refer attached spreadsheet
45
 11/11/2016
 05
 Refer attached spreadsheet
46
 18/11/2016
 46
 Refer attached spreadsheet
47
 25/11/2016
 09
 Refer attached spreadsheet
48
 02/12/2016
 35
 Refer attached spreadsheet
49
 09/12/2016
 19
 Refer attached spreadsheet
50
 16/12/2016
 12
 Refer attached spreadsheet
51
 23/12/2016
 26
 Refer attached spreadsheet
52
 30/12/2016
 54
 Refer attached spreadsheet
53
 06/01/2017
 35
 Refer attached spreadsheet
54
 13/01/2017
 12
 Refer attached spreadsheet
55
 20/01/2017
 12
 Refer attached spreadsheet
56
 27/01/2017
 27
 Refer attached spreadsheet
57
 03/02/2017
 26
 Refer attached spreadsheet
58
 10/02/2017
 19
 Refer attached spreadsheet
57
 17/02/2017
 25
 Refer attached spreadsheet
58
 24/02/2017
 39
 Refer attached spreadsheet
59
 03/03/2017
 30
 Refer attached spreadsheet
60
 10/03/2017
 4
 Refer attached spreadsheet
61
 17/03/2017
 20
 Refer attached spreadsheet
62
 24/03/2017
 24
 Refer attached spreadsheet


Please find attached spreadsheet below for the details about the reports failed till 31/03/2017:

BI Failed Reports February 2017.xlsx


Resolution
1. Need to identify the failed reports based on the Notification Emails.
2. Rerun the reports that failed due to server issues.
3. Fix the reports, if required after notifying NEC.

Release Information

None